<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  
  <title>mysql5.7升级小版本 | 清峰小栈</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  
  <meta name="keywords" content="windows" />
  
  
  
  
  <meta name="description" content="mysql5.7升级小版本-windows 在centos7环境中从5.7.26升级到5.7.37请看：密码：qot9 https:&#x2F;&#x2F;zrzyjyb.yuque.com&#x2F;docs&#x2F;share&#x2F;eba5d4c6-b5bf-4e1b-ac46-b75e3be1f18b  应用场景：mysql 5.7.20升级到当前最新的5.7.31 ，Windows环境 官网下载链接：https:&#x2F;&#x2F;dev.mys">
<meta property="og:type" content="article">
<meta property="og:title" content="Mysql5.7升级小版本">
<meta property="og:url" content="http://example.com/2022/03/09/Mysql/Mysql5.7%E5%8D%87%E7%BA%A7%E5%B0%8F%E7%89%88%E6%9C%AC/index.html">
<meta property="og:site_name" content="清峰小栈">
<meta property="og:description" content="mysql5.7升级小版本-windows 在centos7环境中从5.7.26升级到5.7.37请看：密码：qot9 https:&#x2F;&#x2F;zrzyjyb.yuque.com&#x2F;docs&#x2F;share&#x2F;eba5d4c6-b5bf-4e1b-ac46-b75e3be1f18b  应用场景：mysql 5.7.20升级到当前最新的5.7.31 ，Windows环境 官网下载链接：https:&#x2F;&#x2F;dev.mys">
<meta property="og:locale" content="en_US">
<meta property="article:published_time" content="2022-03-09T03:04:17.963Z">
<meta property="article:modified_time" content="2023-05-03T14:12:01.678Z">
<meta property="article:author" content="清峰">
<meta property="article:tag" content="windows">
<meta name="twitter:card" content="summary">
  

  

  <link rel="icon" href="/qingfeng-blog/css/images/mylogo-2.png">
  <link rel="apple-touch-icon" href="/qingfeng-blog/css/images/mylogo-2.png">
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  <link href="https://fonts.googleapis.com/css?family=Open+Sans|Montserrat:700" rel="stylesheet" type="text/css">
  <link href="https://fonts.googleapis.com/css?family=Roboto:400,300,300italic,400italic" rel="stylesheet" type="text/css">
  <!-- <link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet"> -->
  <link href="/qingfeng-blog/css/font-awesome.css" rel="stylesheet">
  <style type="text/css">
    @font-face{font-family:futura-pt; src:url("/qingfeng-blog/css/fonts/FuturaPTBold.otf") format("woff");font-weight:500;font-style:normal;}
    @font-face{font-family:futura-pt-light; src:url("/qingfeng-blog/css/fonts/FuturaPTBook.otf") format("woff");font-weight:lighter;font-style:normal;}
    @font-face{font-family:futura-pt-italic; src:url("/qingfeng-blog/css/fonts/FuturaPTBookOblique.otf") format("woff");font-weight:400;font-style:italic;}
}

  </style>
  
<link rel="stylesheet" href="/qingfeng-blog/css/style.css">


  
<script src="/qingfeng-blog/js/jquery-3.1.1.min.js"></script>

  
<script src="/qingfeng-blog/js/bootstrap.js"></script>


  <!-- Bootstrap core CSS -->
  <link rel="stylesheet" href="/qingfeng-blog/css/bootstrap.css" >

  
    
<link rel="stylesheet" href="/qingfeng-blog/css/dialog.css">

  

  

  
    <link rel="stylesheet" href="/qingfeng-blog/css/header-post.css" >
  

  
  
  
    <link rel="stylesheet" href="/qingfeng-blog/css/vdonate.css" >
  

<meta name="generator" content="Hexo 6.3.0"></head>



  <body data-spy="scroll" data-target="#toc" data-offset="50">


  
  <div id="container">
    <div id="wrap">
      
        <header>

    <div id="allheader" class="navbar navbar-default navbar-static-top" role="navigation">
        <div class="navbar-inner">
          
          <div class="container"> 
            <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
              <span class="sr-only">Toggle navigation</span>
              <span class="icon-bar"></span>
              <span class="icon-bar"></span>
              <span class="icon-bar"></span>
            </button>

            
              <a class="brand" style="
                 border-width: 0px;  margin-top: 0px;"  
                href="#" data-toggle="modal" data-target="#myModal" >
                  <img width="155px" height="90px" alt="Hike News" src="/qingfeng-blog/css/images/mylogo-2.png">
              </a>
            
            
            <div class="navbar-collapse collapse">
              <ul class="hnav navbar-nav">
                
                  <li> <a class="main-nav-link" href="/qingfeng-blog/">首页</a> </li>
                
                  <li> <a class="main-nav-link" href="/qingfeng-blog/categories">分类</a> </li>
                
                  <li> <a class="main-nav-link" href="/qingfeng-blog/tags">标签</a> </li>
                
                  <li><div id="search-form-wrap">

    <form class="search-form">
        <input type="text" class="ins-search-input search-form-input" placeholder="" />
        <button type="submit" class="search-form-submit"></button>
    </form>
    <div class="ins-search">
    <div class="ins-search-mask"></div>
    <div class="ins-search-container">
        <div class="ins-input-wrapper">
            <input type="text" class="ins-search-input" placeholder="Type something..." />
            <span class="ins-close ins-selectable"><i class="fa fa-times-circle"></i></span>
        </div>
        <div class="ins-section-wrapper">
            <div class="ins-section-container"></div>
        </div>
    </div>
</div>
<script>
(function (window) {
    var INSIGHT_CONFIG = {
        TRANSLATION: {
            POSTS: 'Posts',
            PAGES: 'Pages',
            CATEGORIES: 'Categories',
            TAGS: 'Tags',
            UNTITLED: '(Untitled)',
        },
        ROOT_URL: '/qingfeng-blog/',
        CONTENT_URL: '/qingfeng-blog/content.json',
    };
    window.INSIGHT_CONFIG = INSIGHT_CONFIG;
})(window);
</script>

<script src="/qingfeng-blog/js/insight.js"></script>


</div></li>
            </div>
          </div>
                
      </div>
    </div>

</header>



      
            
      <div id="content" class="outer">
        
          <section id="main" style="float:none;"><article id="post-Mysql/Mysql5.7升级小版本" style="width: 75%; float:left;" class="article article-type-post" itemscope itemprop="blogPost" >
<div id="container">
  <div id="articleInner" class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 class="thumb" class="article-title" itemprop="name">
      Mysql5.7升级小版本
    </h1>
  

      </header>
    
    <div class="article-meta">
      
	<a href="/qingfeng-blog/2022/03/09/Mysql/Mysql5.7%E5%8D%87%E7%BA%A7%E5%B0%8F%E7%89%88%E6%9C%AC/" class="article-date">
	  <time datetime="2022-03-09T03:04:17.963Z" itemprop="datePublished">2022-03-09</time>
	</a>

      
    <a class="article-category-link" href="/qingfeng-blog/categories/Mysql/">Mysql</a>

      
	<a class="article-views">
	<span id="busuanzi_container_page_pv">
		PV:<span id="busuanzi_value_page_pv"></span>
	</span>
	</a>

      

    </div>
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="mysql5-7升级小版本-windows"><a href="#mysql5-7升级小版本-windows" class="headerlink" title="mysql5.7升级小版本-windows"></a>mysql5.7升级小版本-windows</h2><blockquote>
<p>在centos7环境中从5.7.26升级到5.7.37请看：密码：qot9</p>
<p><a target="_blank" rel="noopener" href="https://zrzyjyb.yuque.com/docs/share/eba5d4c6-b5bf-4e1b-ac46-b75e3be1f18b">https://zrzyjyb.yuque.com/docs/share/eba5d4c6-b5bf-4e1b-ac46-b75e3be1f18b</a></p>
</blockquote>
<p>应用场景：mysql 5.7.20升级到当前最新的5.7.31 ，Windows环境</p>
<p>官网下载链接：<a target="_blank" rel="noopener" href="https://dev.mysql.com/downloads/mysql/5.7.html">https://dev.mysql.com/downloads/mysql/5.7.html</a></p>
<p><strong>注意：操作前mysql数据一定一定先备份，以免安装过程中出问题能够补救</strong></p>
<h2 id="一、关闭并删除mysql服务"><a href="#一、关闭并删除mysql服务" class="headerlink" title="一、关闭并删除mysql服务"></a>一、关闭并删除mysql服务</h2><p>先记录一下mysql的安装路径</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br></pre></td><td class="code"><pre><span class="line">//查看mysql安装路径</span><br><span class="line">select @@basedir as basePath from dual;</span><br><span class="line">//查看mysql data数据存放路径</span><br><span class="line">show global variables like &#x27;%datadir%&#x27;;</span><br></pre></td></tr></table></figure>

<p>再服务窗口关闭mysql服务</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br></pre></td><td class="code"><pre><span class="line">//cmd切换盘符e:</span><br><span class="line">//cd到安装路径bin目录下</span><br><span class="line">E:/MySQL/mysql&gt;cd bin</span><br><span class="line">//移除mysql服务</span><br><span class="line">E:/MySQL/mysql/bin&gt;mysqld —remove</span><br><span class="line">Service successfully removed.</span><br><span class="line"></span><br><span class="line">E:/MySQL/mysql/bin&gt;cd ..</span><br><span class="line"></span><br><span class="line">E:/MySQL/mysql&gt;cd ..</span><br></pre></td></tr></table></figure>

<h2 id="二、替换mysql-相关文件"><a href="#二、替换mysql-相关文件" class="headerlink" title="二、替换mysql 相关文件"></a>二、替换mysql 相关文件</h2><p>将mysql文件夹改名，然后将新版本解压命名为mysql将原来的my.ini和data目录拷贝到mysql文件夹中</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br></pre></td><td class="code"><pre><span class="line">E:/MySQL&gt;cd mysql</span><br><span class="line">E:/MySQL&gt;cd bin</span><br><span class="line">//安装mysql服务</span><br><span class="line">E:/MySQL/mysql&gt;mysqld —install</span><br><span class="line">Service successfully installed.</span><br></pre></td></tr></table></figure>

<h2 id="三、启动mysql服务"><a href="#三、启动mysql服务" class="headerlink" title="三、启动mysql服务"></a>三、启动mysql服务</h2><p>重新打开服务窗口，启动mysql服务</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br></pre></td><td class="code"><pre><span class="line">E:/MySQL/mysql&gt;cd bin</span><br><span class="line">E:/MySQL/mysql/bin&gt;mysql -u root -p</span><br><span class="line">输入原先的密码</span><br><span class="line"></span><br><span class="line">//查看mysql版本</span><br><span class="line">mysql&gt; select version();</span><br><span class="line">+—————-+</span><br><span class="line">| version() |</span><br><span class="line">+—————-+</span><br><span class="line">| 5.7.37 |</span><br><span class="line">+—————-+</span><br><span class="line">1 row in set (0.00 sec)</span><br><span class="line"></span><br><span class="line">mysql&gt; exit</span><br><span class="line">Bye</span><br></pre></td></tr></table></figure>

<p><strong>第三步操作能正常启动可直接跳到第四步。</strong></p>
<blockquote>
<p>注意：我在本机上测试，一，二步操作完后，第三步服务能够启动。但在生产环境下却启动不起来。</p>
<p>我在cmd输入启动命令：net start msql的时候提示“服务报告没有任何错误”。</p>
<p>原因：安装完mysql服务后迫不及待的开启mysql服务，在mysql5.7以上版本中默认没有一个data目录，即没有初始化服务。需要先初始化mysql才可以启动服务mysqld  –initialize-insecure，否则会报 “服务没有报告任何错误”，启动失败。</p>
<p>1）我这里是因为生产上的mysql数据存放目录data在其他文件夹中，我替换了mysql安装目录后，配置文件my.ini中直接将数据存放目录引导至data所在路径，结果报错。</p>
<p>2）将data路径放置mysql安装目录下，修改配置文件数据存放路径datadir即可，即可启动成功。</p>
<p>3）还是启动不成功就执行mysqld  –initialize-insecure将数据库初始化，然后在启动，注意初始化后你的数据库相当于重置了，是一个全新的数据库，需要重新设置密码，导库操作。</p>
</blockquote>
<h2 id="四、执行升级操作"><a href="#四、执行升级操作" class="headerlink" title="四、执行升级操作"></a>四、执行升级操作</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br><span class="line">52</span><br><span class="line">53</span><br><span class="line">54</span><br><span class="line">55</span><br><span class="line">56</span><br><span class="line">57</span><br><span class="line">58</span><br><span class="line">59</span><br><span class="line">60</span><br><span class="line">61</span><br><span class="line">62</span><br><span class="line">63</span><br><span class="line">64</span><br><span class="line">65</span><br><span class="line">66</span><br><span class="line">67</span><br><span class="line">68</span><br><span class="line">69</span><br><span class="line">70</span><br><span class="line">71</span><br><span class="line">72</span><br><span class="line">73</span><br><span class="line">74</span><br><span class="line">75</span><br><span class="line">76</span><br><span class="line">77</span><br><span class="line">78</span><br><span class="line">79</span><br><span class="line">80</span><br><span class="line">81</span><br><span class="line">82</span><br><span class="line">83</span><br><span class="line">84</span><br><span class="line">85</span><br><span class="line">86</span><br><span class="line">87</span><br><span class="line">88</span><br><span class="line">89</span><br><span class="line">90</span><br><span class="line">91</span><br><span class="line">92</span><br></pre></td><td class="code"><pre><span class="line">E:/MySQL/mysql/bin&gt;mysql_upgrade.exe -uroot -p 密码</span><br><span class="line">提示：</span><br><span class="line">mysql_upgrade: [Warning] Using a password on the command line interface can be i</span><br><span class="line">nsecure.</span><br><span class="line">Checking if update is needed.</span><br><span class="line">Checking server version.</span><br><span class="line">Running queries to upgrade MySQL server.</span><br><span class="line">Checking system database.</span><br><span class="line">mysql.columns_priv OK</span><br><span class="line">mysql.db OK</span><br><span class="line">mysql.engine_cost OK</span><br><span class="line">mysql.event OK</span><br><span class="line">mysql.func OK</span><br><span class="line">mysql.general_log OK</span><br><span class="line">mysql.gtid_executed OK</span><br><span class="line">mysql.help_category OK</span><br><span class="line">mysql.help_keyword OK</span><br><span class="line">mysql.help_relation OK</span><br><span class="line">mysql.help_topic OK</span><br><span class="line">mysql.innodb_index_stats OK</span><br><span class="line">mysql.innodb_table_stats OK</span><br><span class="line">mysql.ndb_binlog_index OK</span><br><span class="line">mysql.plugin OK</span><br><span class="line">mysql.proc OK</span><br><span class="line">mysql.procs_priv OK</span><br><span class="line">mysql.proxies_priv OK</span><br><span class="line">mysql.server_cost OK</span><br><span class="line">mysql.servers OK</span><br><span class="line">mysql.slave_master_info OK</span><br><span class="line">mysql.slave_relay_log_info OK</span><br><span class="line">mysql.slave_worker_info OK</span><br><span class="line">mysql.slow_log OK</span><br><span class="line">mysql.tables_priv OK</span><br><span class="line">mysql.time_zone OK</span><br><span class="line">mysql.time_zone_leap_second OK</span><br><span class="line">mysql.time_zone_name OK</span><br><span class="line">mysql.time_zone_transition OK</span><br><span class="line">mysql.time_zone_transition_type OK</span><br><span class="line">mysql.user OK</span><br><span class="line">Found outdated sys schema version 1.5.1.</span><br><span class="line">Upgrading the sys schema.</span><br><span class="line">Checking databases.</span><br><span class="line">ejabberd.archive OK</span><br><span class="line">ejabberd.archive_prefs OK</span><br><span class="line">ejabberd.archive_search_result OK</span><br><span class="line">ejabberd.archive_search_task OK</span><br><span class="line">ejabberd.bosh OK</span><br><span class="line">ejabberd.caps_features OK</span><br><span class="line">ejabberd.carboncopy OK</span><br><span class="line">ejabberd.im_muc_room_member OK</span><br><span class="line">ejabberd.im_muc_room_stat OK</span><br><span class="line">ejabberd.im_sys_config OK</span><br><span class="line">ejabberd.im_unread_message OK</span><br><span class="line">ejabberd.irc_custom OK</span><br><span class="line">ejabberd.last OK</span><br><span class="line">ejabberd.motd OK</span><br><span class="line">ejabberd.msg_item OK</span><br><span class="line">ejabberd.muc_online_room OK</span><br><span class="line">ejabberd.muc_online_users OK</span><br><span class="line">ejabberd.muc_registered OK</span><br><span class="line">ejabberd.muc_room OK</span><br><span class="line">ejabberd.muc_room_dissolved OK</span><br><span class="line">ejabberd.oauth_token OK</span><br><span class="line">ejabberd.privacy_default_list OK</span><br><span class="line">ejabberd.privacy_list OK</span><br><span class="line">ejabberd.privacy_list_data OK</span><br><span class="line">ejabberd.private_storage OK</span><br><span class="line">ejabberd.proxy65 OK</span><br><span class="line">ejabberd.pubsub_item OK</span><br><span class="line">ejabberd.pubsub_node OK</span><br><span class="line">ejabberd.pubsub_node_option OK</span><br><span class="line">ejabberd.pubsub_node_owner OK</span><br><span class="line">ejabberd.pubsub_state OK</span><br><span class="line">ejabberd.pubsub_subscription_opt OK</span><br><span class="line">ejabberd.roster_version OK</span><br><span class="line">ejabberd.rostergroups OK</span><br><span class="line">ejabberd.rosterusers OK</span><br><span class="line">ejabberd.route OK</span><br><span class="line">ejabberd.sm OK</span><br><span class="line">ejabberd.spool OK</span><br><span class="line">ejabberd.sr_group OK</span><br><span class="line">ejabberd.sr_user OK</span><br><span class="line">ejabberd.user_favorite_contact OK</span><br><span class="line">ejabberd.user_favorite_group_def OK</span><br><span class="line">ejabberd.user_mc_room OK</span><br><span class="line">ejabberd.user_sign OK</span><br><span class="line">ejabberd.users OK</span><br><span class="line">ejabberd.vcard OK</span><br><span class="line">ejabberd.vcard_search OK</span><br><span class="line">sys.sys_config OK</span><br><span class="line">Upgrade process completed successfully.</span><br><span class="line">Checking if update is needed.</span><br></pre></td></tr></table></figure>

<h2 id="五、重启mysql服务并验证版本"><a href="#五、重启mysql服务并验证版本" class="headerlink" title="五、重启mysql服务并验证版本"></a>五、重启mysql服务并验证版本</h2><p>重启mysql服务</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br></pre></td><td class="code"><pre><span class="line">//进入mysql</span><br><span class="line">E:/MySQL/mysql/bin&gt;mysql -u root -p</span><br><span class="line">密码：</span><br><span class="line"></span><br><span class="line">//查看版本</span><br><span class="line">mysql&gt; select version();</span><br><span class="line">//查看数据库</span><br><span class="line">mysql&gt; show databases;</span><br></pre></td></tr></table></figure>

<p>完毕</p>

      
    </div>
    <footer class="article-footer">
      
        <div id="donation_div"></div>


<script src="/qingfeng-blog/js/vdonate.js"></script>

<script>
var a = new Donate({
  title: '如果觉得我的文章对您有用，请随意打赏。您的支持将鼓励我继续创作!', // 可选参数，打赏标题
  btnText: 'Donate', // 可选参数，打赏按钮文字
  el: document.getElementById('donation_div'),
  wechatImage: 'http://img.lindaifeng.vip/typora-picgo-tuchaung/20230428150832.png',
  alipayImage: 'http://img.lindaifeng.vip/typora-picgo-tuchaung/20230428150823.png'
});
</script>
      
      
      <div>
        <ul class="post-copyright">
          <li class="post-copyright-author">
          <strong>Post author:  </strong>清峰</a>
          </li>
          <li class="post-copyright-link">
          <strong>Post link:  </strong>
          <a href="/qingfeng-blog/2022/03/09/Mysql/Mysql5.7升级小版本/" target="_blank" title="Mysql5.7升级小版本">http://example.com/2022/03/09/Mysql/Mysql5.7升级小版本/</a>
          </li>
          <li class="post-copyright-license">
            <strong>Copyright Notice:   </strong>
            All articles in this blog are licensed under <a rel="license" href="https://creativecommons.org/licenses/by-nc-nd/4.0/" target="_blank" title="Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0)">CC BY-NC-ND 4.0</a>
            unless stating additionally.
          </li>
         
        </ul>
<div>

      
      
        
	<div id="comment">
		<!-- 来必力City版安装代码 -->
		<div id="lv-container" data-id="city" data-uid="MTAyMC8yOTQ4MS82MDQ5">
		<script type="text/javascript">
		   (function(d, s) {
		       var j, e = d.getElementsByTagName(s)[0];

		       if (typeof LivereTower === 'function') { return; }

		       j = d.createElement(s);
		       j.src = 'https://cdn-city.livere.com/js/embed.dist.js';
		       j.async = true;

		       e.parentNode.insertBefore(j, e);
		   })(document, 'script');
		</script>
		<noscript>为正常使用来必力评论功能请激活JavaScript</noscript>
		</div>
		<!-- City版安装代码已完成 -->
	</div>



      
      
        
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/qingfeng-blog/tags/windows/" rel="tag">windows</a></li></ul>

      

    </footer>
  </div>
</div>
  
    
<nav id="article-nav">
  
    <a href="/qingfeng-blog/2022/04/20/%E8%BF%90%E7%BB%B4%E5%AE%89%E8%A3%85/Linux%20kubesphere%E5%9C%A8%E7%BA%BF%E5%85%A8%E6%B5%81%E7%A8%8B%E6%90%AD%E5%BB%BA/" id="article-nav-newer" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Newer</strong>
      <div class="article-nav-title">
        
          Linux kubesphere在线全流程搭建
        
      </div>
    </a>
  
  
    <a href="/qingfeng-blog/2022/01/27/Docker/Docker%E4%BB%8B%E7%BB%8D/" id="article-nav-older" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Older</strong>
      <div class="article-nav-title">Docker介绍</div>
    </a>
  
</nav>

  
</article>

<!-- Table of Contents -->

  <aside id="toc-sidebar">
    <div id="toc" class="toc-article">
    <strong class="toc-title">Contents</strong>
    
        <ol class="nav"><li class="nav-item nav-level-2"><a class="nav-link" href="#mysql5-7%E5%8D%87%E7%BA%A7%E5%B0%8F%E7%89%88%E6%9C%AC-windows"><span class="nav-number">1.</span> <span class="nav-text">mysql5.7升级小版本-windows</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#%E4%B8%80%E3%80%81%E5%85%B3%E9%97%AD%E5%B9%B6%E5%88%A0%E9%99%A4mysql%E6%9C%8D%E5%8A%A1"><span class="nav-number">2.</span> <span class="nav-text">一、关闭并删除mysql服务</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#%E4%BA%8C%E3%80%81%E6%9B%BF%E6%8D%A2mysql-%E7%9B%B8%E5%85%B3%E6%96%87%E4%BB%B6"><span class="nav-number">3.</span> <span class="nav-text">二、替换mysql 相关文件</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#%E4%B8%89%E3%80%81%E5%90%AF%E5%8A%A8mysql%E6%9C%8D%E5%8A%A1"><span class="nav-number">4.</span> <span class="nav-text">三、启动mysql服务</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#%E5%9B%9B%E3%80%81%E6%89%A7%E8%A1%8C%E5%8D%87%E7%BA%A7%E6%93%8D%E4%BD%9C"><span class="nav-number">5.</span> <span class="nav-text">四、执行升级操作</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#%E4%BA%94%E3%80%81%E9%87%8D%E5%90%AFmysql%E6%9C%8D%E5%8A%A1%E5%B9%B6%E9%AA%8C%E8%AF%81%E7%89%88%E6%9C%AC"><span class="nav-number">6.</span> <span class="nav-text">五、重启mysql服务并验证版本</span></a></li></ol>
    
    </div>
  </aside>


</section>
        
      </div>
      
      <footer id="footer">
  

  <div class="container">
      	<div class="row">
	      <!-- <p> Powered by <a href="http://hexo.io/" target="_blank">Hexo</a> and <a href="https://github.com/iTimeTraveler/hexo-theme-hiker" target="_blank">Hexo-theme-hiker</a> </p> -->
	      <p>May there be no bug in the world！</p>
        <p id="copyRightEn">Copyright &copy; 2022 - 2023 All Rights Reserved.</p>
	      
	      
    		<p class="busuanzi_uv">
				UV : <span id="busuanzi_value_site_uv"></span> |  
				PV : <span id="busuanzi_value_site_pv"></span>
		    </p>
  		   
		</div>

		
  </div>
</footer>


<!-- min height -->

<script>
    var wrapdiv = document.getElementById("wrap");
    var contentdiv = document.getElementById("content");
    var allheader = document.getElementById("allheader");

    wrapdiv.style.minHeight = document.body.offsetHeight + "px";
    if (allheader != null) {
      contentdiv.style.minHeight = document.body.offsetHeight - allheader.offsetHeight - document.getElementById("footer").offsetHeight + "px";
    } else {
      contentdiv.style.minHeight = document.body.offsetHeight - document.getElementById("footer").offsetHeight + "px";
    }
</script>
    </div>
    <!-- <nav id="mobile-nav">
  
    <a href="/qingfeng-blog/" class="mobile-nav-link">首页</a>
  
    <a href="/qingfeng-blog/categories" class="mobile-nav-link">分类</a>
  
    <a href="/qingfeng-blog/tags" class="mobile-nav-link">标签</a>
  
</nav> -->
    

<!-- mathjax config similar to math.stackexchange -->

<script type="text/x-mathjax-config">
  MathJax.Hub.Config({
    tex2jax: {
      inlineMath: [ ['$','$'], ["\\(","\\)"] ],
      processEscapes: true
    }
  });
</script>

<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
      tex2jax: {
        skipTags: ['script', 'noscript', 'style', 'textarea', 'pre', 'code']
      }
    });
</script>

<script type="text/x-mathjax-config">
    MathJax.Hub.Queue(function() {
        var all = MathJax.Hub.getAllJax(), i;
        for(i=0; i < all.length; i += 1) {
            all[i].SourceElement().parentNode.className += ' has-jax';
        }
    });
</script>

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.1/MathJax.js?config=TeX-AMS-MML_HTMLorMML">
</script>


  
<link rel="stylesheet" href="/qingfeng-blog/fancybox/jquery.fancybox.css">

  
<script src="/qingfeng-blog/fancybox/jquery.fancybox.pack.js"></script>




<script src="/qingfeng-blog/js/scripts.js"></script>



  
<script src="/qingfeng-blog/js/home.js"></script>




  
<script src="/qingfeng-blog/js/dialog.js"></script>









	<div style="display: none;">
    <script src="https://s95.cnzz.com/z_stat.php?id=1260716016&web_id=1260716016" language="JavaScript"></script>
  </div>



	<script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js">
	</script>






  </div>

  <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" style="display: none;">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h2 class="modal-title" id="myModalLabel">设置</h2>
      </div>
      <hr style="margin-top:0px; margin-bottom:0px; width:80%; border-top: 3px solid #000;">
      <hr style="margin-top:2px; margin-bottom:0px; width:80%; border-top: 1px solid #000;">


      <div class="modal-body">
          <div style="margin:6px;">
            <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" onclick="javascript:setFontSize();" aria-expanded="true" aria-controls="collapseOne">
              正文字号大小
            </a>
          </div>
          <div id="collapseOne" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingOne">
          <div class="panel-body">
            您已调整页面字体大小
          </div>
        </div>
      


          <div style="margin:6px;">
            <a data-toggle="collapse" data-parent="#accordion" href="#collapseTwo" onclick="javascript:setBackground();" aria-expanded="true" aria-controls="collapseTwo">
              夜间护眼模式
            </a>
        </div>
          <div id="collapseTwo" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingTwo">
          <div class="panel-body">
            夜间模式已经开启，再次单击按钮即可关闭 
          </div>
        </div>

        <div>
            <a data-toggle="collapse" data-parent="#accordion" href="#collapseThree" aria-expanded="true" aria-controls="collapseThree">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;关 于&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
        </div>
         <div id="collapseThree" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingThree">
          <div class="panel-body">
            清峰小栈
          </div>
          <div class="panel-body">
            Copyright © 2023 清峰 All Rights Reserved.
          </div>
        </div>
      </div>


      <hr style="margin-top:0px; margin-bottom:0px; width:80%; border-top: 1px solid #000;">
      <hr style="margin-top:2px; margin-bottom:0px; width:80%; border-top: 3px solid #000;">
      <div class="modal-footer">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
      </div>
    </div>
  </div>
</div>
  
  <a id="rocket" href="#top" class=""></a>
  <script type="text/javascript" src="/qingfeng-blog/js/totop.js?v=1.0.0" async=""></script>
  
    <a id="menu-switch"><i class="fa fa-bars fa-lg"></i></a>
  
</body>
</html>